| Datenbänke | ![]() |
Diese Information ist nur relevant wenn Sie eine Lizenz Fisa Logger besitzen. Siehe Fisa Logger
Fisa Logger databases have the extension *.cmb. Dateiextensionen
These databases are only used for saving Production data with Fisa Logger License.
Die Datenbänke können mit Access 2000(in Microsoft Office 2000 Professional or later)geöffnet werden. By default, the databases are password protected. Sie können das Kennwort ändern oder entfernen. Wie das Kennwort geändert wird
Fisa Logger arbeitet mit zwei Datenbänken:
Logger Master serves as the template for creating a new Installation.cmb (working database).
Logger.cmb will be named as your Installation name, eg My First Installation.cmb.
The structure of the Logger.cmb will therefore be the same as for Logger Master.cmb,
except for the table Operators which exists only in the Logger Master.cmb.
Logger Master.cmb
Located in the application path
Sie müssen das Kennwort für Logger Master.cmb kennen, um in Administratorebene hereinzukommen.
Administratorebene
Logger.cmb
Located in the same path as the *.cmg file.
Normalerweise
\Fisa Software\Fisa Project\Installations\MyFirst Installation.cmb.
Dateiextensionen
This database is created as a copy of Logger Master.cmb whenever creating a new installation. The Logger.cmb could also be created if it is not found at the same location as the *.cmg file.
The Logger.cmb can have a different password than the one in Logger Master.cmb.
Struktur

How Data are Created and Saved
The most important queries for data mining in the Logger database are already included in Fisa Logger. Der Korbanalysator
This does not exclude that you might want to prepare your own, more refined, queries based on the stucture described above.
Beispiel Abfrage
A query like this one is easily constructed in the Access 2000 Query design interface:

The produced SQL string looks like this:
SELECT Baskets.*, Baskets.Barcode FROM ((Operators INNER JOIN [Session] ON Operators.Operator = Session.Operator) INNER JOIN Baskets ON Session.Counter = Baskets.SessionID) INNER JOIN Visits ON Baskets.Counter = Visits.BasketsID WHERE (((Baskets.Barcode) Like "????###AB*"));